SELECT Id FROM new_searchtable
where (town like 'Lyme' and state='NH'
or town like 'Enfield' and state='NH'
or town like 'Lebanon' and state='NH'
or town like 'Hanover' and state='NH'
or town like 'Plainfield'and state='NH'
or town like 'Cornish'and state='NH'
or town like 'Grantham'and state='NH'
or town like 'Eastman'and state='NH'
or town like 'Dorchester'and state='NH' )
and list_price > '700000' and (type = 'R' or type ='O')
and (bedrooms >='4') and (bedrooms >='4')
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Dartmouth Area Luxury NH Homes page 20
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:This substantial expanded Cape offers an exceptional blend of multi-generational living, extensive workspace, and expansive acreage. The main residence features five bedrooms and four and a half bathrooms, anchored by a beautiful Crown Point Cabinetry kitchen equipped with abundant cabinet and counter space, a woodstove, and direct access to a porch designed for summer dining. A large, elegant living room centers around a classic Rumford fireplace. Recent updates include a new oil-fired boiler with ten heating zones alongside a whole-house generator. A two-car garage provides convenient attached parking. Complementing the main house is a detached guest house featuring a character-rich post and beam upper frame with a sleeping loft and a full bathroom. For projects and storage, the property includes a 24x60 storage building and a premier 24x44 workshop outfitted with radiant floor heat, an 80-gallon compressor, and a 2,000-pound traveling hoist. Set on 107.5 acres, the grounds feature an in-ground saltwater swimming pool, an established pond, a seasonal brook, and an extensive network of trails and wood roads. Beautiful landscaping frames the home, complete with mature plantings of blueberries, rhubarb, and Christmas trees, creating a private and versatile rural retreat.
Description:Just a short stroll from the Lyme Common sits a charming one-of-a-kind gem! Once a blacksmith shop, now a truly unique thoughtfully reimagined home with wonderful gathering spaces enriched by hardwood and wide pine floors, quality built-ins and even a fabulous patio where you can enjoy a cup of coffee while taking in beautiful gardens and an expansive lawn. The property consists of a four-bedroom main house in addition to a 2019 built two-bedroom cottage presently being used as an office. Wander up Market Street to find restaurants, shops and award-winning Lyme Elementary School or get there via The Big Rock Nature Preserve trail directly across from your front door. Lyme offers many recreational opportunities from the Dartmouth Skiway, cross country skiing at the Greens to Post Pond for swimming and of course extensive hiking trails and a short drive to Dartmouth College, Hanover and DHMC. Open Houses Sat May 23 & Sun May 24 from 12-2pm.The listing agent holds an ownership interest in the property.
Description:Set on lovely, landscaped grounds, this inviting Colonial offers space, charm and exceptional warmth throughout. The home's floor plan features a beautiful eat-in kitchen, a formal living room and dining room and a conveniently located comfortable family room with a gas fireplace and a den/office. Off the family room is a fabulous year round sunroom/screen porch that opens onto a private deck creating wonderful spaces for summer entertaining and relaxation. A large mudroom off the kitchen with a 3/4 bath, serves as a convenient entrance for snowy or rainy days. The second floor has 4 bedrooms, an office and 2 full baths providing plenty of space for family and guests. A final standout feature of this home is the finished basement with an expansive rec room, exercise room, laundry room and a convenient half bath. This home is a must see!!
Description:3 Lewin Road checks every box and then some. Turn-key, beautifully updated, and just a few blocks from Hanover's Main Street, this 4-bedroom, 3.5-bath Cape is deceptively spacious and unmistakably well-done. A complete 2025 reimagination brought a showstopper gourmet kitchen -quartzite countertops, paneled Sub-Zero, induction range with pro-bake and air fry, retractable brass pot-filler, custom cabinetry, and concealed ventilation - along with a long list of stunning updates that complement the flexible floor plan, including primary suites on both levels. The main floor open-concept living space flows seamlessly through doors that open directly to the backyard, where a full-length deck, pergola, garden shed, and fire pit area create an outdoor entertaining sequence for every season. Upstairs, three generously sized bedrooms offer comfortable separation. The expansive basement delivers serious storage and potential to expand your living space. An attached one-car garage rounds out the package. Steps from the Mink Brook trailhead, close to the Connecticut River, Hanover High School, and Dartmouth College Campus, it's the rare property that it earns that in-town cottage charm without any of the compromise. The list of recent renovations and improvements to this 3-story property is long and ready to be enjoyed by the next homeowners for years to come.
Description:Set in one of Hanover’s most desirable locations, this exceptional property offers privacy, lifestyle, and refined living just minutes from downtown. Originally built in 1850, this beautifully restored Cape blends historic charm with a substantial modern addition, creating an impressive 4,500 sq. ft. home. A preserved portion of the antique home adds character, while the newer addition features an open-concept layout ideal for everyday living and entertaining. The home has been extensively renovated with radiant heat, updated baths, and a gourmet kitchen. A formal dining room and elegant living room with fireplace open through French doors to a wraparound covered porch overlooking perennial gardens, open fields, and established trails with fruit trees and berry bushes. Recent improvements include new kitchen flooring, updated lighting, fresh interior paint, and major climate upgrades with two whole-house heat pump/AC systems plus three split units serving the garage, first-floor bedroom, and den. A propane fireplace insert adds warmth and ambiance. The finished lower level offers flexible space for a home office, family room, and gym, with added lighting, shelving, and basement waterproofing. Exterior updates include a new roof, rebuilt dormers, full exterior repainting, new gutters, paved driveway, and a newly built three-car garage with electrical service, along with a rebuilt attached two-car garage and additional outbuildings. The landscaped grounds feature stone walls, gardens, expanded trails, fenced areas, and enhanced lighting and security systems. Numerous additional improvements have been completed—see full list of upgrades in the listing documents. Open House Saturday, May 30th 10am-12pm